package jpa.entitys.synchro.staging;

import java.io.Serializable;

import javax.persistence.*;

import java.util.Date;


/**
 * The persistent class for the SD_CUSTO_REQU_DEDUC_OUTB database table.
 * 
 */
@Entity
@Table(name="SD_CUSTO_REQU_DEDUC_OUTB")
@NamedQueries({
    @NamedQuery(name = "SdCustoRequDeducOutb.findAll", query = " SELECT c FROM SdCustoRequDeducOutb c "),
    @NamedQuery(name = "SdCustoRequDeducOutb.findById", query = " SELECT c FROM SdCustoRequDeducOutb c WHERE c.promisStagingId = :Id "),
    @NamedQuery(name = "SdCustoRequDeducOutb.findByInstanceNo", query = " SELECT c FROM SdCustoRequDeducOutb c WHERE c.instanceNo = :instanceNo And c.issync = 'N' order by c.promisStagingId asc"),
    @NamedQuery(name = "SdCustoRequDeducOutb.findAllIsSync", query = " SELECT c FROM SdCustoRequDeducOutb c WHERE c.issync = :issync order by c.instanceNo asc")
    })
public class SdCustoRequDeducOutb extends jpa.entitys.synchro.common.CommonEntity implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@Column(name="PROMIS_STAGING_ID", unique=true, nullable=false, length=100)
	private String promisStagingId;
	
	@Override public String toString() { return org.apache.commons.lang.builder.ToStringBuilder.reflectionToString(this);}

	@Column(name="ACTION_HANDLER", length=20)
	private String actionHandler;

	@Column(name="BANK_AC_TYPE", length=10)
	private String bankAcType;

	@Column(name="BANK_ACCOUNT_NAME", length=100)
	private String bankAccountName;

	@Column(name="BANK_ACCOUNT_NO", length=100)
	private String bankAccountNo;

	@Column(name="BANK_COUNTRY", length=10)
	private String bankCountry;

	@Column(name="BANK_DATE_FOR_DEDUCT", length=10)
	private String bankDateForDeduct;

	@Column(name="BANK_DEDUCT_AMOUNT", length=30)
	private String bankDeductAmount;

	@Column(name="BANK_DEDUCT_PERIOD", length=10)
	private String bankDeductPeriod;

	@Column(name="BANK_END_PAY", length=100)
	private String bankEndPay;

	@Column(name="BANK_KEY", length=100)
	private String bankKey;

	@Column(name="BANK_REMARKS", length=1000)
	private String bankRemarks;

	@Column(name="BANK_START_PAY", length=100)
	private String bankStartPay;

	@Column(name="BANK_STATUS", length=100)
	private String bankStatus;

	@Column(name="CARD_BANK_CODE", length=100)
	private String cardBankCode;

	@Column(name="CARD_CREDIT_CARD_NAME", length=300)
	private String cardCreditCardName;

	@Column(name="CARD_CREDIT_CARD_NO", length=100)
	private String cardCreditCardNo;

	@Column(name="CARD_DATE_FOR_DEDUCT", length=10)
	private String cardDateForDeduct;

	@Column(name="CARD_DEDUCT_AMOUNT", length=30)
	private String cardDeductAmount;

	@Column(name="CARD_DEDUCT_PERIOD", length=100)
	private String cardDeductPeriod;

	@Column(name="CARD_END_PAY", length=100)
	private String cardEndPay;

	@Column(name="CARD_START_PAY", length=100)
	private String cardStartPay;

	@Column(name="CARD_STATUS", length=100)
	private String cardStatus;

	@Column(name="CARD_TYPE", length=10)
	private String cardType;

	@Column(name="CARD_VALID_FROM", length=100)
	private String cardValidFrom;

	@Column(name="CARD_VALID_TO", length=100)
	private String cardValidTo;

	@Column(name="CREATED_BY", length=30)
	private String createdBy;

	@Column(name="CREATED_ON", length=20)
	private String createdOn;

	@Column(name="CUSTOMER_CODE", length=100)
	private String customerCode;

	@Column(name="DOCUMENT_NO", length=100)
	private String documentNo;

	@Column(name="EXT_REF_KEY", length=100)
	private String extRefKey;

	@Column(name="EXT_REF_NO", length=100)
	private String extRefNo;

	@Column(name="INSTANCE_NO", length=100)
	private String instanceNo;

	@Column(length=1)
	private String isactive;

	@Column(length=1)
	private String issync;

	@Column(name="MSG_ACT_RESULT", length=3707)
	private String msgActResult;

	@Column(name="MSG_ALT_DESC", length=3700)
	private String msgAltDesc;

	@Column(name="MSG_CODE", length=1500)
	private String msgCode;

	@Column(name="MSG_DESC", length=3700)
	private String msgDesc;

	@Column(name="SYNC_CREATEDBY", length=100)
	private String syncCreatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_CREATEDON")
	private Date syncCreatedon;

	@Column(name="SYNC_UPDATEDBY", length=100)
	private String syncUpdatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_UPDATEDON")
	private Date syncUpdatedon;

	@Column(name="UPDATED_BY", length=30)
	private String updatedBy;

	@Column(name="UPDATED_ON", length=20)
	private String updatedOn;
	
	@Column(name="CONTRACT_NO", length=100)
	private String contractNo;
	
	@Column(name="CUS_REQU_TYPE", length=100)
	private String cusRequType;

	@Column(name="COMPANY", length=100)
	private String company;
	
	@Column(name="PROJECT", length=100)
	private String project;
	
	@Column(name="SAP_PLANT_CODE", length=100)
	private String sapPlantCode;
	
	@Column(name="SAP_COMPANY_CODE", length=100)
	private String sapCompanyCode;
	
	@Column(name="STATUS", length=100)
	private String status;
	
	@Column(name="INTERFACE_NO", length=100)
	private String interfaceNo;	
	
    /**
	 * @return the interfaceNo
	 */
	public String getInterfaceNo() {
		return interfaceNo;
	}

	/**
	 * @param interfaceNo the interfaceNo to set
	 */
	public void setInterfaceNo(String interfaceNo) {
		this.interfaceNo = interfaceNo;
	}
	
    /**
	 * @return the status
	 */
	public String getStatus() {
		return status;
	}

	/**
	 * @param status the status to set
	 */
	public void setStatus(String status) {
		this.status = status;
	}

	/**
	 * @return the company
	 */
	public String getCompany() {
		return company;
	}

	/**
	 * @param company the company to set
	 */
	public void setCompany(String company) {
		this.company = company;
	}

	/**
	 * @return the project
	 */
	public String getProject() {
		return project;
	}

	/**
	 * @param project the project to set
	 */
	public void setProject(String project) {
		this.project = project;
	}

	/**
	 * @return the sapPlantCode
	 */
	public String getSapPlantCode() {
		return sapPlantCode;
	}

	/**
	 * @param sapPlantCode the sapPlantCode to set
	 */
	public void setSapPlantCode(String sapPlantCode) {
		this.sapPlantCode = sapPlantCode;
	}

	/**
	 * @return the sapCompanyCode
	 */
	public String getSapCompanyCode() {
		return sapCompanyCode;
	}

	/**
	 * @param sapCompanyCode the sapCompanyCode to set
	 */
	public void setSapCompanyCode(String sapCompanyCode) {
		this.sapCompanyCode = sapCompanyCode;
	}

	public SdCustoRequDeducOutb() {
    }

	/**
	 * @return the cusRequType
	 */
	public String getCusRequType() {
		return cusRequType;
	}
	
	/**
	 * @param cusRequType the cusRequType to set
	 */
	public void setCusRequType(String cusRequType) {
		this.cusRequType = cusRequType;
	}
	
	/**
	 * @return the contractNo
	 */
	public String getContractNo() {
		return contractNo;
	}
	
	/**
	 * @param contractNo the contractNo to set
	 */
	public void setContractNo(String contractNo) {
		this.contractNo = contractNo;
	}
	
	public String getPromisStagingId() {
		return this.promisStagingId;
	}

	public void setPromisStagingId(String promisStagingId) {
		this.promisStagingId = promisStagingId;
	}

	public String getActionHandler() {
		return this.actionHandler;
	}

	public void setActionHandler(String actionHandler) {
		this.actionHandler = actionHandler;
	}

	public String getBankAcType() {
		return this.bankAcType;
	}

	public void setBankAcType(String bankAcType) {
		this.bankAcType = bankAcType;
	}

	public String getBankAccountName() {
		return this.bankAccountName;
	}

	public void setBankAccountName(String bankAccountName) {
		this.bankAccountName = bankAccountName;
	}

	public String getBankAccountNo() {
		return this.bankAccountNo;
	}

	public void setBankAccountNo(String bankAccountNo) {
		this.bankAccountNo = bankAccountNo;
	}

	public String getBankCountry() {
		return this.bankCountry;
	}

	public void setBankCountry(String bankCountry) {
		this.bankCountry = bankCountry;
	}

	public String getBankDateForDeduct() {
		return this.bankDateForDeduct;
	}

	public void setBankDateForDeduct(String bankDateForDeduct) {
		this.bankDateForDeduct = bankDateForDeduct;
	}

	public String getBankDeductAmount() {
		return this.bankDeductAmount;
	}

	public void setBankDeductAmount(String bankDeductAmount) {
		this.bankDeductAmount = bankDeductAmount;
	}

	public String getBankDeductPeriod() {
		return this.bankDeductPeriod;
	}

	public void setBankDeductPeriod(String bankDeductPeriod) {
		this.bankDeductPeriod = bankDeductPeriod;
	}

	public String getBankEndPay() {
		return this.bankEndPay;
	}

	public void setBankEndPay(String bankEndPay) {
		this.bankEndPay = bankEndPay;
	}

	public String getBankKey() {
		return this.bankKey;
	}

	public void setBankKey(String bankKey) {
		this.bankKey = bankKey;
	}

	public String getBankRemarks() {
		return this.bankRemarks;
	}

	public void setBankRemarks(String bankRemarks) {
		this.bankRemarks = bankRemarks;
	}

	public String getBankStartPay() {
		return this.bankStartPay;
	}

	public void setBankStartPay(String bankStartPay) {
		this.bankStartPay = bankStartPay;
	}

	public String getBankStatus() {
		return this.bankStatus;
	}

	public void setBankStatus(String bankStatus) {
		this.bankStatus = bankStatus;
	}

	public String getCardBankCode() {
		return this.cardBankCode;
	}

	public void setCardBankCode(String cardBankCode) {
		this.cardBankCode = cardBankCode;
	}

	public String getCardCreditCardName() {
		return this.cardCreditCardName;
	}

	public void setCardCreditCardName(String cardCreditCardName) {
		this.cardCreditCardName = cardCreditCardName;
	}

	public String getCardCreditCardNo() {
		return this.cardCreditCardNo;
	}

	public void setCardCreditCardNo(String cardCreditCardNo) {
		this.cardCreditCardNo = cardCreditCardNo;
	}

	public String getCardDateForDeduct() {
		return this.cardDateForDeduct;
	}

	public void setCardDateForDeduct(String cardDateForDeduct) {
		this.cardDateForDeduct = cardDateForDeduct;
	}

	public String getCardDeductAmount() {
		return this.cardDeductAmount;
	}

	public void setCardDeductAmount(String cardDeductAmount) {
		this.cardDeductAmount = cardDeductAmount;
	}

	public String getCardDeductPeriod() {
		return this.cardDeductPeriod;
	}

	public void setCardDeductPeriod(String cardDeductPeriod) {
		this.cardDeductPeriod = cardDeductPeriod;
	}

	public String getCardEndPay() {
		return this.cardEndPay;
	}

	public void setCardEndPay(String cardEndPay) {
		this.cardEndPay = cardEndPay;
	}

	public String getCardStartPay() {
		return this.cardStartPay;
	}

	public void setCardStartPay(String cardStartPay) {
		this.cardStartPay = cardStartPay;
	}

	public String getCardStatus() {
		return this.cardStatus;
	}

	public void setCardStatus(String cardStatus) {
		this.cardStatus = cardStatus;
	}

	public String getCardType() {
		return this.cardType;
	}

	public void setCardType(String cardType) {
		this.cardType = cardType;
	}

	public String getCardValidFrom() {
		return this.cardValidFrom;
	}

	public void setCardValidFrom(String cardValidFrom) {
		this.cardValidFrom = cardValidFrom;
	}

	public String getCardValidTo() {
		return this.cardValidTo;
	}

	public void setCardValidTo(String cardValidTo) {
		this.cardValidTo = cardValidTo;
	}

	public String getCreatedBy() {
		return this.createdBy;
	}

	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	public String getCreatedOn() {
		return this.createdOn;
	}

	public void setCreatedOn(String createdOn) {
		this.createdOn = createdOn;
	}

	public String getCustomerCode() {
		return this.customerCode;
	}

	public void setCustomerCode(String customerCode) {
		this.customerCode = customerCode;
	}

	public String getDocumentNo() {
		return this.documentNo;
	}

	public void setDocumentNo(String documentNo) {
		this.documentNo = documentNo;
	}

	public String getExtRefKey() {
		return this.extRefKey;
	}

	public void setExtRefKey(String extRefKey) {
		this.extRefKey = extRefKey;
	}

	public String getExtRefNo() {
		return this.extRefNo;
	}

	public void setExtRefNo(String extRefNo) {
		this.extRefNo = extRefNo;
	}

	public String getInstanceNo() {
		return this.instanceNo;
	}

	public void setInstanceNo(String instanceNo) {
		this.instanceNo = instanceNo;
	}

	public String getIsactive() {
		return this.isactive;
	}

	public void setIsactive(String isactive) {
		this.isactive = isactive;
	}

	public String getIssync() {
		return this.issync;
	}

	public void setIssync(String issync) {
		this.issync = issync;
	}

	public String getMsgActResult() {
		return this.msgActResult;
	}

	public void setMsgActResult(String msgActResult) {
		this.msgActResult = msgActResult;
	}

	public String getMsgAltDesc() {
		return this.msgAltDesc;
	}

	public void setMsgAltDesc(String msgAltDesc) {
		this.msgAltDesc = msgAltDesc;
	}

	public String getMsgCode() {
		return this.msgCode;
	}

	public void setMsgCode(String msgCode) {
		this.msgCode = msgCode;
	}

	public String getMsgDesc() {
		return this.msgDesc;
	}

	public void setMsgDesc(String msgDesc) {
		this.msgDesc = msgDesc;
	}

	public String getSyncCreatedby() {
		return this.syncCreatedby;
	}

	public void setSyncCreatedby(String syncCreatedby) {
		this.syncCreatedby = syncCreatedby;
	}

	public Date getSyncCreatedon() {
		return this.syncCreatedon;
	}

	public void setSyncCreatedon(Date syncCreatedon) {
		this.syncCreatedon = syncCreatedon;
	}

	public String getSyncUpdatedby() {
		return this.syncUpdatedby;
	}

	public void setSyncUpdatedby(String syncUpdatedby) {
		this.syncUpdatedby = syncUpdatedby;
	}

	public Date getSyncUpdatedon() {
		return this.syncUpdatedon;
	}

	public void setSyncUpdatedon(Date syncUpdatedon) {
		this.syncUpdatedon = syncUpdatedon;
	}

	public String getUpdatedBy() {
		return this.updatedBy;
	}

	public void setUpdatedBy(String updatedBy) {
		this.updatedBy = updatedBy;
	}

	public String getUpdatedOn() {
		return this.updatedOn;
	}

	public void setUpdatedOn(String updatedOn) {
		this.updatedOn = updatedOn;
	}

}